﻿CREATE proc [dbo].[proc_Customer_Industry_Delete_Check]
(
	@id int
)
AS
BEGIN
	DECLARE @coun INT
	DECLARE @fhz NVARCHAR(MAX)
	set @coun=(SELECT COUNT(*) FROM Customer_Industry ci WHERE ci.FId=@id)
	IF(@coun>0)
	SET @fhz=(SELECT Title FROM  Customer_Industry WHERE id=@id)
	ELSE
		SET @fhz=''
	select @fhz
END
		